#2 -- Use setNull
PreparedStatement stmt =
  con.prepareStatement("update emp
  set dept = ? where emp_id = 71164");
stmt.setString(1,""); // wrong!!
stmt.setNull(1);

stmt.executeUpdate();

Return to Tracks